SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlRelRolesUsuarios
AS
SELECT dbo.tb_relUsuarioRol.idUsuario AS id, dbo.tb_relUsuarioRol.idRol, dbo.vwrRoles.descripcion AS Rol
FROM  dbo.tb_relUsuarioRol INNER JOIN
               dbo.vwrRoles ON dbo.tb_relUsuarioRol.idRol = dbo.vwrRoles.id
GO
GRANT SELECT ON  [dbo].[vwlRelRolesUsuarios] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vwlRelRolesUsuarios] TO [SoloVer]
GO
